gsc_entity_mnemonic table — gscem
The gsc_entity_mnemonic table is the central table of the Entity and Defaults group. This table stores all the hard-coded entity mnemonics allocated to every table in an application. It defines a meaningful short code and identifies the table name for each table. It also defines generic information about the entity for use when generating dynamic objects or generic objects based on the table, and when auto-generating triggers.
Table 4–1 lists the table’s FLA, fields, and foreign keys.
Table 4–1: gsc_entity_mnemonic table information
|
Table FLA
|
Fields (data type)
|
Foreign keys
|
|
gscem
|
entity_mnemonic (Character)
entity_mnemonic_short_desc (Character)
entity_mnemonic_description (Character)
auto_properform_strings (Logical)
entity_mnemonic_label_prefix (Character)
entity_mnemonic_obj (Character)
entity_description_field (Character)
entity_description_procedure (Character)
entity_narration (Character)
entity_object_field (Character)
table_has_object_field (Logical)
entity_key_field (Character)
table_prefix_length (Integer)
field_name_separator (Character)
auditing_enabled (Logical)
version_data (Logical)
deploy_data (Logical)
entity_dbname (Character)
replicate_entity_mnemonic (Character)
replicate_key (Character)
scm_field_name (Character)
reuse_deleted_keys (Logical)
|
entity_mnemonic
|
Table 4–2 gives details of the table’s indexes.
Table 4–2: gsc_entity_mnemonic index information
|
Index name
|
Elements
|
Type
|
|
XPKgsc_entity_mnemonic
|
entity_mnemonic
|
Primary Unique
|
|
XAK1gsc_entity_mnemonic
|
entity_mnemonic_obj
|
Unique
|
|
XIE1gsc_entity_mnemonic
|
entity_mnemonic_short_desc
|
Nonunique
|
|
XIE2gsc_entity_mnemonic
|
entity_mnemonic_description
|
Nonunique
|
|
XIE3gsc_entity_mnemonic
|
deploy_data
entity_mnemonic
|
Nonunique
|
|
XIE4gsc_entity_mnemonic
|
replicate_entity_mnemonic
|
Nonunique
|
|
XIE5gsc_entity_mnemonic
|
version_data
entity_mnemonic
|
Nonunique
|